Tabela Address

Definicja tabeli Address

Name

Address

Code

Address

Comment

 


Lista kolumn tabeli Address

Name

Code

AddressID

AddressID

AddressTypeID

AddressTypeID

AdmCodeID

AdmCodeID

Street

Street

HomeNo

HomeNo

FlatNo

FlatNo

PostalCode

PostalCode

Place

Place

Country

Country

Phone

Phone

Fax

Fax

Email

Email

www

www

Telex

Telex

Detailed

Detailed

DescriptiveAddress

DescriptiveAddress


Kolumna AddressID tabeli Address

Definicja kolumny AddressID tabeli Address

Name

AddressID

Code

AddressID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AddressTypeID tabeli Address

Definicja kolumny AddressTypeID tabeli Address

Name

AddressTypeID

Code

AddressTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AdmCodeID tabeli Address

Definicja kolumny AdmCodeID tabeli Address

Name

AdmCodeID

Code

AdmCodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Street tabeli Address

Definicja kolumny Street tabeli Address

Name

Street

Code

Street

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna HomeNo tabeli Address

Definicja kolumny HomeNo tabeli Address

Name

HomeNo

Code

HomeNo

Data Type

VARCHAR2(6)

Mandatory

No

Comment

 


Kolumna FlatNo tabeli Address

Definicja kolumny FlatNo tabeli Address

Name

FlatNo

Code

FlatNo

Data Type

VARCHAR2(6)

Mandatory

No

Comment

 


Kolumna PostalCode tabeli Address

Definicja kolumny PostalCode tabeli Address

Name

PostalCode

Code

PostalCode

Data Type

VARCHAR2(6)

Mandatory

No

Comment

 


Kolumna Place tabeli Address

Definicja kolumny Place tabeli Address

Name

Place

Code

Place

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Country tabeli Address

Definicja kolumny Country tabeli Address

Name

Country

Code

Country

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Phone tabeli Address

Definicja kolumny Phone tabeli Address

Name

Phone

Code

Phone

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Fax tabeli Address

Definicja kolumny Fax tabeli Address

Name

Fax

Code

Fax

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Email tabeli Address

Definicja kolumny Email tabeli Address

Name

Email

Code

Email

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna www tabeli Address

Definicja kolumny www tabeli Address

Name

www

Code

www

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Telex tabeli Address

Definicja kolumny Telex tabeli Address

Name

Telex

Code

Telex

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Detailed tabeli Address

Definicja kolumny Detailed tabeli Address

Name

Detailed

Code

Detailed

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna DescriptiveAddress tabeli Address

Definicja kolumny DescriptiveAddress tabeli Address

Name

DescriptiveAddress

Code

DescriptiveAddress

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Lista kluczy tabeli Address

Name

Code

Primary

PK_ADDRESS

PK_ADDRESS

X


Klucz PK_ADDRESS tabeli Address

Definicja klucza PK_ADDRESS tabeli Address

Name

PK_ADDRESS

Code

PK_ADDRESS

Primary

Yes

Comment